Labels:text | screenshot | font | number | document | information OCR: Human Resources Employee Transaction Fact Table Dimension Employee transs cion key Employee transaction key Month toys Employee ID Organization key Transaction Descaption Salary:98is Month Dimension Tensaction Die doma Overtime Paid Overtime Hours Last _Transas jon150g Retirement Paid month atenbites Namet Vacation Enmoed Adpresse Job Grades Number_Promotions Education+ Number Transfers Appraisal_ Rating: Number Hires Organization Dimenton Last Review Date Rethement Balanot Retirement Planant Vocation Babarice: veorganizat hisatt itutes Health Insurance Plans Vacation Flan- And many more: Figure 1. The Human Resources Data Mart dimensional model. The fact table is a snapshot that contains monthly numeric summaries that are difficult to calculate from the underlying transactions. The employee transaction dimension table contains a record for every transaction per- formed on every employee record. All of the employee attributes start- ing with Name actually consist of multiple fields, indicated by a plus sign.
(1999).iso/dbmsa/feb98/kimbf101.gif){kind=small}
(1999).iso/dbmsa/feb98/indef101.gif){kind=link}
(1999).iso/dbmsa/feb98/lintf101.gif){kind=link}